How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Ryan-CTech Your Own Question
Ryan-CTech, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 524
Experience:  Expert VBA Programmer.
Type Your Microsoft Office Question Here...
Ryan-CTech is online now
A new question is answered every 9 seconds

Excel 2007 - need personal.xlsb macros to run when sheet is

Customer Question

Excel 2007 - need personal.xlsb macros to run when sheet is hidden. It works on my other computers but not one I am currently on. Macro runs when file is not hidden.

Also would like help understanding trust center settings so all my maros run without message bar warning.
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Lindie-mod replied 4 years ago.


I'm a moderator for this topic. I've been working hard to find a Professional to assist you with your Excel, but sometimes finding the right Professional can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.

Thank you!


Expert:  Ryan-CTech replied 4 years ago.
Hi and welcome to JA :),

You could unhide and rehide the sheet and see if it works. Try this


Sub HideAndSeek()
'Unhides the Worksheet, runs some code and rehides the worksheet
'Sheet1 is the hidden worksheet. Change it as needed.

Sheet1.Visible = xlSheetVisible '<<< Unhides the sheet
Sheet1.Range("A1").Value = ":)" '<<< Your code goes here
Sheet1.Visible = xlSheetHidden '<<< Hides the sheet again

End Sub


Please let me know if I can assist you further. I am always here to help. :)
Expert:  Ryan-CTech replied 4 years ago.
Any luck?

Related Microsoft Office Questions