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
Ryan-CTech, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 524
Experience:  Expert VBA Programmer.
18042535
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.

Hi,

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!

Lindie

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