I have excel workbook which contains more than 80 sheets , i want to create links to cell A2 in sheet1 to all active sheets at once
I have excel workbook which contains more than 80 sheets , i want to create links to cell A2 in sheet1 to all active sheets at once
Not sure what you mean by "all active sheets". There is only one active sheet. Do you mean all visible sheets?
Try something like this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
all visible sheets
Did Alphafrog's code give you the answer? In which case, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks