Hyperlink to Same sheet but after that want to hide link sheet
Hello Sir,
I create button on sheet1 and hyperlink this button to open sheet2. after that i hide sheet2 but when i hide sheet2 link nor work. i want to button work after hidding the sheet can u help me. |
Hyperlink to Same sheet but after that want to hide link sheet
Hello Sir,
I create button on sheet1 and hyperlink this button to open sheet2. after that i hide sheet2 but when i hide sheet2 link nor work. i want to button work after hidding the sheet can u help me. In order to display hidden sheets you need to set their 'Visible' property... Sheets("Sheet2").Visible = True ...where I assume you're talking about sheets in a workbook. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
All times are GMT +1. The time now is 12:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com