Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in excel macro
Hi
I have a excel program that does timesheets. Inside of the macros it has 2 Microsoft Excel objects: Sheet2 (datasheet) and Sheet7 (TIMESHEET) and ThisWorkbook. The Sheet7 is the excel worksheet itself and I'm trying to access the Sheet2 (datasheet) because in the code have some references to parameters that maybe have in this datasheet: For example: FileDirectory1$ = Worksheets("datasheet").Range("SETUP_FileDirectory 1") The only problem is, nobody here in the company knows how to open this datasheet because if I double click it does not show me the datasheet. I need some help to maybe figure out how to open this datasheet. Thanks Eduardo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in excel macro
I am not clear as to the problem when you double-click it, but is it hidden.
Go to FormatSheetUnhide and see if it is in the list, if so unhide it. It may be very hidden, in which case go to the VBIDE and select that sheet in the explorer, and check the Visible property (F4). Change it if it is. -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message oups.com... Hi I have a excel program that does timesheets. Inside of the macros it has 2 Microsoft Excel objects: Sheet2 (datasheet) and Sheet7 (TIMESHEET) and ThisWorkbook. The Sheet7 is the excel worksheet itself and I'm trying to access the Sheet2 (datasheet) because in the code have some references to parameters that maybe have in this datasheet: For example: FileDirectory1$ = Worksheets("datasheet").Range("SETUP_FileDirectory 1") The only problem is, nobody here in the company knows how to open this datasheet because if I double click it does not show me the datasheet. I need some help to maybe figure out how to open this datasheet. Thanks Eduardo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel-Macro Problem | Excel Discussion (Misc queries) | |||
problem with macro on Excel | Excel Worksheet Functions | |||
excel macro problem | Excel Programming | |||
Excel 2k3 Macro Problem | Excel Programming | |||
Excel XP macro problem | Excel Programming |