I have an excel file that i want to share with my colleagues.
and it should only show a dummysheet with a text showing " Enable Macros to view the Master Sheet" Once the user enables macros. this dummy sheet should be changed to veryhidden and the MasterSheet should become visible which is currently is with veryhidden status.
also the user should get a messagebox that "thank you" Macro is enabled"
any help is appreciated.