Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sight Unseen
I have a worksheet in my workbook that is used as a master copy. I hav a macro that creates new worksheets based on this worksheet. I want t hide the master worksheet so that it can not be seen an therefore i less likly to be altered. However when I hide this sheet all of th copies that are made from this sheet also hide. Is there a way or a code that will allow me to hide this sheet bu still allow the copies that are made from it to be visible? I would really like to know. I am learning vba as I go so if this is stupid or easy question don't hammer me to hard about it -- oberon.blac ----------------------------------------------------------------------- oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673 View this thread: http://www.excelforum.com/showthread.php?threadid=40204 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sight Unseen
Post the part of the code that creates the new sheet.
Jon "oberon.black" wrote in message news:oberon.black.1ux2ye_1125975913.0863@excelforu m-nospam.com... I have a worksheet in my workbook that is used as a master copy. I have a macro that creates new worksheets based on this worksheet. I want to hide the master worksheet so that it can not be seen an therefore is less likly to be altered. However when I hide this sheet all of the copies that are made from this sheet also hide. Is there a way or a code that will allow me to hide this sheet but still allow the copies that are made from it to be visible? I would really like to know. I am learning vba as I go so if this is a stupid or easy question don't hammer me to hard about it. -- oberon.black ------------------------------------------------------------------------ oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732 View this thread: http://www.excelforum.com/showthread...hreadid=402045 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No longer supporting sight? | Excel Discussion (Misc queries) | |||
Eye-sight and errors | Excel Discussion (Misc queries) | |||
Sight Lines | Excel Discussion (Misc queries) | |||
spreadsheet on web sight | Excel Discussion (Misc queries) | |||
Clearing unseen data | New Users to Excel |