| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Modules not working
Hi
I have the following code which should remove modules have it doesn't seem to work unless I step through it using F8. Activesheet.cmdSendEmail.Visible = True Application.SendKeys ("%te" & "^{TAB}" & "{TAB}{DEL}" & "{TAB}{DEL}" & "{ENTER}") Call RemoveModules Cells.Select Selection.Locked = True Range("B6").Select Call ProtectSheet ActiveWorkbook.SaveAs "C:\Adv.xls" MsgBox "CLICK EMAIL BUTTON", vbOKOnly Any suggestions would be very much appreciated. Thanks Noemi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Public, Private, Event modules, Forms modules,,, | Excel Programming | |||
| Basic question - modules and class modules - what's the difference? | Excel Programming | |||
| When to code in sheet or userform modules and when to use modules | Excel Programming | |||
| VBA & XL2K: Working with objects/class modules | Excel Programming | |||
| Remove code from all modules closes Excel | Excel Programming | |||
Threaded Mode
