LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default I need help deleting macros and VB controls and saving as new workbook

I am trying to copy a sheet from a workbook then create a new file with
the file name as cell H4 then I need it to delete all of the macros
and command buttons THEN I need to protect the whole new file so
nothing is editable its for an invoice.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
saving macros in personal workbook porbeagle Excel Worksheet Functions 1 March 30th 07 11:56 AM
Saving a workbook separately to its macros PipTT Excel Discussion (Misc queries) 0 February 1st 06 10:44 PM
deleting macros that are not really in my workbook? mydogpeanut Excel Worksheet Functions 1 November 22nd 05 10:42 PM
Close a workbook without saving macros Papa Jonah Excel Programming 12 October 27th 04 12:43 AM
Deleting ActiveX Controls Ron[_12_] Excel Programming 1 October 16th 03 03:42 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"