| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Hidden sheets to specific point
Hi All, Lets hope my internet won't crash before this one posts...AGAIN...lol I have hidden sheets that I have got a macro to open once the button is selected, but I want the macro to open at a specific point. Here is the END only of the macro Sheet54.Visible = xlSheetVisible Sheet2.Visible = xlSheetVisible Range("C8").Select End Sub How do I do this, so that Sheet26 is the one that the macro opens at? Thanks in advance Sandi -- rhani111 ------------------------------------------------------------------------ rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940 View this thread: http://www.excelforum.com/showthread...hreadid=556276 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Hidden sheets to specific point
At the end try using
Sheet26.Activate Range("YourRange").Activate "rhani111" wrote: Hi All, Lets hope my internet won't crash before this one posts...AGAIN...lol I have hidden sheets that I have got a macro to open once the button is selected, but I want the macro to open at a specific point. Here is the END only of the macro Sheet54.Visible = xlSheetVisible Sheet2.Visible = xlSheetVisible Range("C8").Select End Sub How do I do this, so that Sheet26 is the one that the macro opens at? Thanks in advance Sandi -- rhani111 ------------------------------------------------------------------------ rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940 View this thread: http://www.excelforum.com/showthread...hreadid=556276 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Hidden sheets to specific point
Thank you ...Thank you...oh Thank you... Worked perfectly!!!!! Sandi -- rhani111 ------------------------------------------------------------------------ rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940 View this thread: http://www.excelforum.com/showthread...hreadid=556276 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I add a hidden comment to a point on an excel graph | Charts and Charting in Excel | |||
| start at a specific point | Charts and Charting in Excel | |||
| opening a worksheet at a specific point | New Users to Excel | |||
| Identifying a specific point on both axis | Charts and Charting in Excel | |||
| Open hidden sheets from a drop down list selection | Excel Discussion (Misc queries) | |||
![rhani111[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
