Unlocking Workbook to Print with Macro Issue

[SLIDE1]

Greetings Peeps who actually know Excel!

I am back yet again with another issue.
The user form I have hacked together works fine until I try to protect the workbook (I do not want anyone to be able to unhide, any sheets).
All the code I have found and tried just creates additional issues and bugs up my Close macro.

The workbook I have attached creates a list of tools used to inspect a job...it works as follows.

Sheet1 A1 input 173 and enter, input an X in column C to choose a tool, fill in part #, Job# (Saved PDF Name), then close.

On close a PDF is created and saved to a file.

Temporary password = MAYDAY

Any and all help is always appreciated !!
Slide1

[BadlySpelledBuoy]

The user form I have hacked together works fine until I try to protect the workbook (I do not want anyone to be able to unhide, any sheets).
All the code I have found and tried just creates additional issues and bugs up my Close macro.

What additional issues are you having? What code have you found and tried?

You can 'hide' sheets from view, and prevent them from being unhidden, by using a Workbook Open event and setting Sheet(X).Visible = xlVeryHidden and UserInterfaceOnly:= True

That way the hidden sheets won't show if you right click a sheet tab and select unhide, yet any VBA you have can perform actions on hidden/protected sheets without issue.

BSB

[SLIDE1]

Thanks BSB..once again after a bit of research I was able to make it work.
Your direction was spot on with the xlVeryHidden suggestion!

[BadlySpelledBuoy]

Happy to help again, SLIDE

BSB