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

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

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