Thread: macros won't work when tabs with data used are hidden
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pywhacket pywhacket is offline
external usenet poster
  
Posts: 16
Default macros won't work when tabs with data used are hidden
Hi! I have macros that on a worksheet that run off data on worksheets, in the
same workbook, that need to be hidden when the workbook is distributed.
Whenever I hide them my macros Iget runtime error '1004' Select method of
worksheet class failed.

Is there a way around this?
Thanks -
Reply With QuoteReply With Quote