Visible = xlVeryHiddenĬreate another macro to hide the sheets when closing Excel Then, insert the following syntax for the event (Each point includes a new line, they are not included in the final code): The macro should be directed to the Open event. To do this, press the “Alt + F11” keys and select “ThisWorkbook” on the left of the panel that is part of the Visual Basic editor. With the new macro you will make all the sheets of the Excel workbook visible and the start sheet will be invisible.
Create a macro to open the Excel fileįirst of all, you need to learn how to create a macro with VBA in Excel. To achieve this, follow the steps that we explain below. If you want to force the user to enable macros in Excel easily it is necessary hide all the sheets that make up the book and leave only one visible where the user will be asked to enable the macros. I believe that the user has to create the workbook that they want to sign, so I don’t know if that even fits your situation.Ĭlick Here Before Posting Data or VBA Code -> How To Post Data or Code.How to force user to enable macros in Excel easily You might want to Google around to see if that option might work. There is also a means to Digital Sign a workbook containing macros as a workaround for this issue, but I am not familiar with the process. When a Trusted Location is used, the macro security settings in Excel are essentially ignored, thereby enabling macros for any files stored there. See this site about storing files in a Trusted Location. At least the user wouldn’t have to go into the Trust Center every time.
I believe that the user is given the option to enable macros just for that file but it might be for just that session. I believe that the “Disable all macros with notification” option will check each file and present a warning if the file contains a macro. I can’t test any of these options at the moment, so I’m working from memory.
Re: “…thought it could be turned off for a particular file”
0 kommentar(er)
