| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime error 1004 - unable to set Visible property of Worksheet c
I have a multi-sheet workbook that has been working fine until now. The only
change I have made is adding another sheet which has a distinct name from the pre-existing ones. However, when I try to use the controls already included on other sheets, I get this runtime error (the sheet should hide itself on exit from that particular set of data). If I delete the newly added sheet I still have the problem in the code that worked fine on other sheets before. If I rem out the offending code (it's a 'with sheets(name) .visible = false end with') then it falls over at the next line. Anyone got any ideas? Thanks SJB |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Runtime error 1004 - unable to set Visible property of Worksheet c
Hi Sue,
At least one sheet needs to be visible and your error will occur if the code attempts to hide the last visible sheet. If this is not your problem, post the relevant control code --- Regards, Norman "SueJB" wrote in message ... I have a multi-sheet workbook that has been working fine until now. The only change I have made is adding another sheet which has a distinct name from the pre-existing ones. However, when I try to use the controls already included on other sheets, I get this runtime error (the sheet should hide itself on exit from that particular set of data). If I delete the newly added sheet I still have the problem in the code that worked fine on other sheets before. If I rem out the offending code (it's a 'with sheets(name) .visible = false end with') then it falls over at the next line. Anyone got any ideas? Thanks SJB |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Runtime error 1004 - unable to set Visible property of Workshe
Hi Norman
That's it - many thanks. I am obviously having a very stupid day :-( Best wishes Sue "Norman Jones" wrote: Hi Sue, At least one sheet needs to be visible and your error will occur if the code attempts to hide the last visible sheet. If this is not your problem, post the relevant control code --- Regards, Norman "SueJB" wrote in message ... I have a multi-sheet workbook that has been working fine until now. The only change I have made is adding another sheet which has a distinct name from the pre-existing ones. However, when I try to use the controls already included on other sheets, I get this runtime error (the sheet should hide itself on exit from that particular set of data). If I delete the newly added sheet I still have the problem in the code that worked fine on other sheets before. If I rem out the offending code (it's a 'with sheets(name) .visible = false end with') then it falls over at the next line. Anyone got any ideas? Thanks SJB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime Error 1004 Unable to set the top property of the picture c | Excel Discussion (Misc queries) | |||
| Error 1004: Unable to get the axis property | Charts and Charting in Excel | |||
| unable to protect cells in macro sheet b/c runtime error 1004 | Excel Worksheet Functions | |||
| Runtime 1004 unable to get find property of range class | Excel Programming | |||
| Run-time error '1004' - Unable to set the Visible property of the Worksheet class | Excel Programming | |||
Hybrid Mode
