| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing hidden sheets
I currently have attributes built into a macrod spreadsheets (dropdow lists) that read the info from a hidden sheet within a workbook. I previously pressed F10 to access VB to alter the values and unhid the sheet. This no longer works. Does anyone have any other ideas -- wilsd ----------------------------------------------------------------------- wilsdo's Profile: http://www.excelforum.com/member.php...fo&userid=1601 View this thread: http://www.excelforum.com/showthread.php?threadid=27483 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing hidden sheets
Try Alt+F11 to call up the Visual Basic Editor
Regards, Alasdair Stirling "wilsdo" wrote: I currently have attributes built into a macrod spreadsheets (dropdown lists) that read the info from a hidden sheet within a workbook. I previously pressed F10 to access VB to alter the values and unhide the sheet. This no longer works. Does anyone have any other ideas? -- wilsdo ------------------------------------------------------------------------ wilsdo's Profile: http://www.excelforum.com/member.php...o&userid=16018 View this thread: http://www.excelforum.com/showthread...hreadid=274836 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing hidden sheets
What happened when you previously hit F10. Did a macro run? If so, how did
you set it up so F10 ran a macro? -- Regards, Tom Ogilvy "wilsdo" wrote in message ... I currently have attributes built into a macrod spreadsheets (dropdown lists) that read the info from a hidden sheet within a workbook. I previously pressed F10 to access VB to alter the values and unhide the sheet. This no longer works. Does anyone have any other ideas? -- wilsdo ------------------------------------------------------------------------ wilsdo's Profile: http://www.excelforum.com/member.php...o&userid=16018 View this thread: http://www.excelforum.com/showthread...hreadid=274836 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Wildcard (*) in formula accessing sheets in workbook. | Excel Worksheet Functions | |||
| Problem with accessing names across sheets | Excel Discussion (Misc queries) | |||
| Accessing All Sheets in a closed workbook | Excel Programming | |||
| Accessing a Hidden and Protected Workbook from a Macro?? | Excel Programming | |||
| Accessing/Clearing range in hidden workbook | Excel Programming | |||
Linear Mode
