hide a worksheet so that a macro can still find it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning.

I am trying to hide worksheets (preferably very hidden) that my macro must
find. Every time I hide the sheets the macro quits working because it can't
find the sheet. Is there a way to hide the sheets frmo a user, but allow the
Macro to find it?
 
Hi frendabrenda1

You can't select cells on a hidden sheet or activate/select it
but you can change values without selectiing.

For example this will work if the sheet is hidden or not
Sheets("Sheet1").Range("A1:D5").Value = "ron"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
hiding an image 2
Hide a worksheet 2
Hiding/Unhiding Rows Automatically 1
Hide macro's 2
Hiding worksheets 7
toolbar "button" for hiding/unhiding sheets 2
hide collumn function is giving error message 1

Back
Top