Forum Discussion
Solved
Shapes Moving Even When set to Do Not Move
I use Excel 365 Enterprise 4 edition. I created a file that is stored on a Teams site that contains shapes I use as buttons for my macros. Every time I open the file the shapes have moved and/or resized and I can't figure out how to prevent this. I have the shapes set to Don't move or size with cells set on each one of them. Users are not moving them. No one is playing any pranks, I wish they were it be a lot easier to fix. Anyone have any ideas?
Providing resolution in case anyone else runs into this issue. Before creating a macro think about how many users may be in your workbook at a time and where the file will be stored (Network, Teams, SharePoint, Etc...). If it is a shared file with many users in it at any given time it would be best not to use macros. Everyone might not have macros enabled and it may be IT restricted. If at all possible, use simple solutions first. In this case using Hyperlinks to guide users to other worksheets in the workbook provided the best solution. A quick search of the web will even show you how to make them look like buttons using formatting tricks.
2 Replies
I wonder if I am using the correct method for madness? What the macro is doing because there are many sheets 10 I am simply unhiding and selecting a sheet when the user selects the button. Then there is a BeforeClose of worksheet hide all sheets except 2. Since this workbook is shared by many I fear this will not work as I suspect and that it may be better to have all sheets open but use hyperlinks instead. I can see the macro getting confused when multi users open the file.
Providing resolution in case anyone else runs into this issue. Before creating a macro think about how many users may be in your workbook at a time and where the file will be stored (Network, Teams, SharePoint, Etc...). If it is a shared file with many users in it at any given time it would be best not to use macros. Everyone might not have macros enabled and it may be IT restricted. If at all possible, use simple solutions first. In this case using Hyperlinks to guide users to other worksheets in the workbook provided the best solution. A quick search of the web will even show you how to make them look like buttons using formatting tricks.