Disabling Macros After One Use

ammdumas · Mar 18th, 2002, 12:32 PM

I have a spreadsheet that imports text data using a macros. I want the macros to be disabled after one import. I do not want the user to use the import macros again (would screw up the spreadsheet). Can it be done?

[ This Message was edited by: ammdumas on 2002-03-18 11:32 ]

NateO · Mar 18th, 2002, 12:37 PM

You could isolate your procedure in a module and place code at the end of the procedure to clear the module of code, like on the post below:

http://www.mrexcel.com/board/viewtop...ic=925&forum=2

You could also store the code in a workbook_open event procedure that would re-write the procedure when the workbook is opened. It will be easier if you have a blank module ready to go. The link at the bottom of the old post will be useful for this.

Hope this helps.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-03-18 17:20 ]

ammdumas · Mar 18th, 2002, 01:39 PM

I give it a shot. Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 12:32 PM	#1
ammdumas Board Regular Join Date: Mar 2002 Location: Waterdown, Ontario Posts: 444	I have a spreadsheet that imports text data using a macros. I want the macros to be disabled after one import. I do not want the user to use the import macros again (would screw up the spreadsheet). Can it be done? [ This Message was edited by: ammdumas on 2002-03-18 11:32 ]

Mar 18th, 2002, 12:37 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	You could isolate your procedure in a module and place code at the end of the procedure to clear the module of code, like on the post below: http://www.mrexcel.com/board/viewtop...ic=925&forum=2 You could also store the code in a workbook_open event procedure that would re-write the procedure when the workbook is opened. It will be easier if you have a blank module ready to go. The link at the bottom of the old post will be useful for this. Hope this helps. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-03-18 17:20 ]

Mar 18th, 2002, 01:39 PM	#3
ammdumas Board Regular Join Date: Mar 2002 Location: Waterdown, Ontario Posts: 444	I give it a shot. Thanks.