Lock cells except for Macro button

S

Sunryzz

I have created a spreadsheet where the user clicks a command button and
enters a number. This number then goes into a table and the table
recalculates a rolling average. I would like to lock the table entries to
user changes unless they are using the macro button. So, if they click in
the table, they can't make any changes, but if they click the macro button,
the macro coding is able to make changes to the table. Is this possible??

Thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top