visual basic
 

I have a file where one of the worksheets is set to invisible. ( 0 -
xlSheetHidden). how ca I switch it to visible? every time I try to change it
a warning box pops up telling me that I cant change. help please?

Is the workbook protected?

tools|protection|unprotect workbook
(You may need to provide a password)

jiwolf wrote:

I have a file where one of the worksheets is set to invisible. ( 0 -
xlSheetHidden). how ca I switch it to visible? every time I try to change it
a warning box pops up telling me that I cant change. help please?

--

Dave Peterson

ah doh!! thanks dave


"Dave Peterson" wrote in message
...
Is the workbook protected?

tools|protection|unprotect workbook
(You may need to provide a password)

jiwolf wrote:

I have a file where one of the worksheets is set to invisible. ( 0 -
xlSheetHidden). how ca I switch it to visible? every time I try to change
it
a warning box pops up telling me that I cant change. help please?

--

Dave Peterson