Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hidden sheet problem
Dear experts,
I've a workbook with 3 worksheets. Sheet 1 is an user form with some macros. This sheet is used for all users to enter data. Sheet 2 is used to collect data automatically transfer from sheet 1. Sheet 3 are data in 3 colums used for combo boxes in the user form in sheet 1. The problem are, when I hide sheet 2 & sheet 3 by choosing "sheetveryhidden" option in VBE (because I don't want ordinary users unhide those sheets from "Format" menu easily), the background in sheet 1 disappeared and sheet 1 could not open properly & normally. This situation will not happen if I hide those sheets by choosing "Format" menu, "Sheet" then "Hide". Can any experts tell me why this happen and any solutions to solve it so that I can hide those sheets in VBE without the above problems? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
JWalk Chart Tools and hidden row problem | Charts and Charting in Excel | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Excel. I am having a problem with hidden text | Excel Discussion (Misc queries) | |||
Sheet hidden and VeryHidden | Excel Discussion (Misc queries) | |||
How to detect if sheet is hidden? | Excel Worksheet Functions |