Nov 30, 2016 Right click any of a tab in the ribbon. And then choose the option “Customize the Ribbon” in the pop-up menu. In the “Excel Options” window, check the tab “Developer” in the “Main Tabs” area. Next click the button “OK” to save the setting. Thus, you have added the tab to the Excel ribbon. Nov 30, 2016 - The security of macro is a key element for the security of Excel. Today we will talk about how to enable/disable macros in your Excel. A Specific Excel Worksheet Is UpdatedOctober 23, 2017In “Outlook PST File Recovery”.
I am sorry, if this already has a thread. It is the first time I am logged on to MREXCEL.com.
![Enable Enable](/uploads/1/2/5/6/125637752/558656241.gif)
I have previously found MREXCEL VERY useful. Now to my question (sorry for my poor English): I would like to 'Force Users to Enable Macros in a Workbook'. I have seen solutions to this problem on many sites, including this one.
However, it seems to me that to work the user must accept macros, otherwise how can the macro run that forces the user to accept macros. Put differently, if the user just ignore 'accept macros' and save the file in the usual XLSX format, he or she can use the spreadsheet without macros? The reason why, I need users to enable macros is quite simply that the spreadsheet is only valid for a specific period of time, and then closes down. However, if the user disregard macros they can continue using the spreadsheet for ever (which is a long time ).
I appreciate any help on the issue. Best regards Christian. It's a little tricky but possible. In essence you add an opening sheet that when the workbook is opened it is the only sheet that is visible. And a button that unhides the sheets using VBA. As the sheets will be hidden via VBA they will be 'veryhidden' meaning they can't be unhidden using the menus The tricky part is the saving. You have to override the saving of sheets so they can't use the manual save button.
Then when the user is saving, you ensure all sheets are 'veryhidden' except the opening sheet. I'm sure if you google it you will find the code. It works charm.