If they don't have macros enabled, they will only see the Reminder tab when the workbook opens.ĭon't forget the password you used to lock the project. Make sure to save the file as a Macro-Enabled Workbook if you are in Excel 2007 and later or the macro won't work.Īs long as the user has macros enabled, they will see the Data tab(s) when the workbook opens. Now close the vba/macro editor window and then close the Excel workbook and save the file when it asks you to do so.Go to the Protection tab and check where it says "Lock project for viewing" and enter a password for the project and then hit OK.To secure the code, we need to right-click over the vba project, located on the left side of the window, and select VBAProject Properties.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |