Clear VBA Code without opening file

[sky1in5]

Hi,

can i clear VBA code in a workbook without opening it? need some experts help on it. Thank you.

 

[James006]

Hi,

Could you elaborate on your underlying objective ...?

You can manipulate VBA code on password-free workbooks you can open ...

HTH

 

[sky1in5]

Hi,

Could you elaborate on your underlying objective ...?

You can manipulate VBA code on password-free workbooks you can open ...

HTH

objective is to clear my worksheet vba code without even opening that worksheet. i need to clear vba but i do not want to open the worksheet because the code is inside thisworkbook as shown below, if open, my data will changed. i do not want to change the data.

Private Sub Workbook_Open()
'My CODING
End Sub

 

[Peter_SSs]

Sounds like a one-off job, so just hold down the Shift key while opening the file. (Make a copy of your file first just in case)

The other option is to disable macros before opening the file.

 

[sky1in5]

Sounds like a one-off job, so just hold down the Shift key while opening the file. (Make a copy of your file first just in case)

The other option is to disable macros before opening the file.

thanks peter, disable macro works.

 

[Peter_SSs]

thanks peter, disable macro works.

I think you would find the other method does too, and is simpler to implement.
Did you give it a try?
Anyway, the main thing is you appear to have a solution.

 

[sky1in5]

I think you would find the other method does too, and is simpler to implement.
Did you give it a try?
Anyway, the main thing is you appear to have a solution.

holding down the shift does not work for me, haha. it really save me alot work for this. thanks.

 

[Peter_SSs]

holding down the shift does not work for me, haha.

Hmm, are you opening the file from within Excel by File > Open or using the recently used file list?
That is, not from Windows Explorer.

See descriptions from Microsoft MVP Jan Karel Pieterse for Excel versions 2010, 2007 and 2003.

 

[sky1in5]

Hmm, are you opening the file from within Excel by File > Open or using the recently used file list?
That is, not from Windows Explorer.

See descriptions from Microsoft MVP Jan Karel Pieterse for Excel versions 2010, 2007 and 2003.

okay it work, you need to open via file dialog inorder to use the shift method. thank you.