Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Protected Sheet with Macro Button


How do I protect a sheet that has a button style macro on it? This macro has sub routines that also run on other sheets within the workbook.

I am trying to have my assemblers enter data into one cell and then use the macro to see if the data is repeated elsewhere.

This macro also queries an outside database to check correlation of the bed serial number entered to the mattress serial number scanned into the database.

It is a multilevel macro that I did not write, so I am unfamiliar with the programming



Hi and welcome to the Forum.

Not sure what you mean by a "button style macro" - do you mean a shape with a macro assigned to it?

It would help us to see your file (if that is possible). Please edit your question and use the Add Files... button to upload a representative Excel file (without any personal data) to show your existing macros and data. Then we should be able to give specific help.
John_Ru (rep: 5572) Sep 10, '22 at 10:07 am
If you don't help us, we can't help you. Sorry 
John_Ru (rep: 5572) Oct 4, '22 at 7:10 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login