Forum Discussion
Shapes Moving Even When set to Do Not Move
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.
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.