Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Macro from View
I am an intermediate user of Excel. I have a workbook
with multiple worksheets which is sent out to multiple individuals for updating. I was helped with writing a Macro to protect all worksheets from changes and also unprotect. My problem is that the Macro and the passwords are visible to the individuals I send the files to. Is there any way I can make the Macros invisible? If possible, please provide "idiot proof" step-by-step instructions as I am very poor in macros and programming. In case you need to know, here are the macros to protect and unprotect: Sub test () Dim a As Integer For a = 1 To Worksheets.Count Worksheets(a).Protect Password:="" Next a End Sub Sub test () Dim a As Integer For a = 1 To Worksheets.Count Worksheets(a).Unprotect Password:="" Next a End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Columns in split view | Excel Worksheet Functions | |||
Resetting view when hiding detail in outline level | Excel Discussion (Misc queries) | |||
help... i might need a macro for this.. (hiding a specific # of ro | New Users to Excel | |||
Hiding Rows in a VBA macro | Excel Discussion (Misc queries) | |||
How do I view cell text without it visually hiding other cells? | Excel Discussion (Misc queries) |