Hello:
Please refer to the code below.
As you can see
' Sheets("1").Select is commented
I want a VB Macro to uncomment that line and comment out line Sheets("2").Select
Please let know if any questions.
Riz
Please Login or Register to view this content.
Last edited by rizmomin; 03-24-2013 at 02:03 PM.
Perhaps this link would help.
Extensibility: code in VBA that reads or modifies other VBA projects, modules, or procedures
Hi AlphaFrog:
I could not find much help at that site.
Please help..
Riz
That site shows you how to use code to write code, which is what you are trying to do as far as I can see.
I've not looked at it recently but as far as I can remember it covers most aspects of doing that.
If posting code please use code tags, see here.
What are you trying to do (big picture) and why do you want to comment\uncomment code with other code?
Hi AlphaFrog:
When I open the excel file, it automatically goes to SheetX1 and lots of other sheets are unhidden.
However, I want to share this file with some other user and before i give it to them i like to change the macro to auto open SheetX2 and hide some sheets.
Please have a look at the code below:
Please Login or Register to view this content.
Hello Riz,
Try something with this code.
Please Login or Register to view this content.
Last edited by HSV; 03-24-2013 at 06:24 PM.
Kind regards, Harry.
Hi Harry:
In module1, I have lots of Macro code.
How would I choose Sub Open()
Thanks
Riz
Self-modifying code was regarded with disdain the day it was invented, and that hasn't changed.
If Environ("username") = "riz" then
' do this
Else
' do that
Endif
Entia non sunt multiplicanda sine necessitate
Hi shg:
I think this is one option i will try.
Thanks a lot for great tip.
Riz
Hi shg:
I think this is one option i will try.
Thanks a lot for great tip.
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks