| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
| Macro Calling Visual Basic References | Excel Discussion (Misc queries) | |||
| I Visual Basic Error "File Not Found" when Excel opens | Excel Discussion (Misc queries) | |||
| Visual Basic Error Message | Excel Discussion (Misc queries) | |||
| Visual Basic Code Remains in "memory" | Excel Worksheet Functions | |||
Linear Mode
