I have a workbook that requires a macro to perform the following tasks upon opening:
I need a pop-up to appear asking the user if he/she has read the appropriate security guidelines before using the workbook. If they click "yes", the workbook will open and all sheets will be unhidden (I need to have them hidden prior to opening just in case a user chooses to disable macros). If they choose "no", the workbook will close.
Any ideas??
Thanks in advance.
P.S. I'm a newbie to VBA so I apologize if this seems like a simple question
I need a pop-up to appear asking the user if he/she has read the appropriate security guidelines before using the workbook. If they click "yes", the workbook will open and all sheets will be unhidden (I need to have them hidden prior to opening just in case a user chooses to disable macros). If they choose "no", the workbook will close.
Any ideas??
Thanks in advance.
P.S. I'm a newbie to VBA so I apologize if this seems like a simple question