Hidden sheet problem

F

Freshman

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match and delete rows on two different sheets from reference numbers 4
selecting workbook/sheet 3
How do you make a summary sheet? 0
Excel formula help for calculating freight. 2
when sheet is active macro is run 2
Assign Macro with Hidden Sheet 5
Create a document from a spread sheet using data from another spre 1
How Can i Link With one sheet to another sheet in Row to Column 1

Top