I have macros that lock down and unlock the contents of my spreadsheet. I don't want my users to be able to run these macros. How would I remove the ability to run macros from the spreadsheet? Ideally, I would like to remove the macro option from the toolbar.
I need a macro that will unprotect my workbook and then unhide a sheet so that I can manipuate some cells on the hidden sheet. I then need to rehide the sheet and protect the workbook.
How can this be done?
Is there is a way to not allow a user to see the Row and Column Headings (Tools Options View) and to not allow a user to check the box to see the Row and Column Headings. In other words - create a spreadsheet where the user can never see the row and column headings.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.