Delete a code

  • Thread starter Thread starter MAX
  • Start date Start date
M

MAX

Hello
How can I delete a code (same code to all sheets) which is inserted in 50
sheets in an excel file? Delete the code sheet by sheet or there is an
alternative way more simple?

Thanks in advance.
 
All I did is that I copied the code sheet by sheet and now I want to delete
that code from all the sheets.
 
th seasies wasy is to manual go to each sheet selecting the sheet in the
vba project window and then tyhpe Cntl-A (select all) and press delete.
It only should take 2 minutes.

You can easily delete all the sheet by selecting all at once and
starting from scratch. remove the vba code.  Then write a very simple
macro to create the sheets

for I = 1 to 50
sheets("sheet1").copy after:=sheets(sheets.count)

next i

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:http://www.thecodecage.com/forumz/showthread.php?t=176984

Microsoft Office Help
Click to expand...

You have to use VBIDE class.

To get that you will have to add "Microsoft Visual Basic for
Applications Extensibility x,xx" . Then you can write a macro to
delete the entire code in 2 sec.
 
Back
Top