-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
private macro
-
How can I get back in to macros that I made private in the past so that I can alter their code?
Hello Everyone, I recently started working in a workbook that I had made quite a few months ago. I had made my macros private because I didn't want users to be able to run them in any way except for through buttons that I had inserted. Now, I want to get back into my macros and work on the...- Glühbirne
- Thread
- excel 10 vba code macro - help private macro private sub
- Replies: 10
- Forum: Excel Questions
-
S
Help! Alter macro to automatically hide/unhide
I have this macro that adjust lines accordingly to the # chosen in the drop down box (using data validation). Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Long If Not Intersect(Target, Range("d1")) Is Nothing Then Range("A10:A1793").EntireRow.Hidden = True r...- swhitesides
- Thread
- hide/unhide row private macro
- Replies: 0
- Forum: Excel Questions
-
S
How to hide/unhide rows based upon cell value from another worksheet
One sheet of my workbook is a master summary sheet where data is entered. Column A contains numbers that we use as a VLookup Reference key for other sheets in this workbook. Example: Master Summary Sheet 1 Bob 2 Fred 3 George 4 .... 105 Now, I want other sheets in this work book to only...- swhitesides
- Thread
- cell value based macro hiding & unhiding rows private macro
- Replies: 0
- Forum: Excel Questions
