Hi,
Is there any code by which we can disable all sheet tabs in a workbook? Sheet tab will shown but when click on it it will not go to that sheet and by only pressing button mapped in Hyperlink will enable and clicking on it it will go to that sheet. Thanks.
You cannot directly disable a visible worksheet tab. However, you can use the Activate event to go to a different sheet if the user clicks the tab. The user may see the sheet flash on the screen for a fraction of a second. Then your code for the button has to disable events, activate the sheet, the re-enable events. The only other way that I can think of to do this is to hide the tab, but you said you want it to be visible.
That is just the strategy, but your question is high-level. I can help with specific code if you attach your workbook.
Hi,
Sorry for the reply delayed. Please provide your mentioned code and hope it will work for me. I don't have any specific sheet for it. I just want this code without hide sheet tabs.
Please provide a sample workbook. To write such code I would have to write it in a workbook and test it. If you provide your file then I won't have to create one from scratch, which may not match what you need. What do you have to start with? Do you have a button and code to go to a sheet? Please provide an example that is as complete as possible.
Hi,
Have attached the file for your reference.
Is this what your after?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Dear Bakerman Sir,
Thank you very much for your code. This is exactly what i needed. You are the one who is constantly help me to resolve most of my queries.
All credit goes to Jeff for giving the perfect pass. Only needed to score.
Glad to help and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks