Hi,
I have a worksheet that has code in the Worksheet_Change event. Through VBA,
I copy that worksheet to a new workbook. Once the Copy is complete, I would
like to delete the Worksheet_Change event code in the copied (new) worksheet.
Can this be done via VBA?
--
TIA
Chuck M.

Yes this is possible
Are you the only user of the code ?

let me know than I give you a good answer


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chuck M" <(E-Mail Removed)> wrote in message news:0D5D9442-C3BA-4B72-B1BB-(E-Mail Removed)...
> Hi,
> I have a worksheet that has code in the Worksheet_Change event. Through VBA,
> I copy that worksheet to a new workbook. Once the Copy is complete, I would
> like to delete the Worksheet_Change event code in the copied (new) worksheet.
> Can this be done via VBA?
> --
> TIA
> Chuck M.

Hi Ron,
Yes I am. The main workbook I created is a company budget with many columns
of data. The columns are hidden and unhidden based on code that fires on the
worksheet-change event. I have a macro that creates separate workbooks for
different departments within the company. Once the company budget is copied
to a new workbook, I hide rows and columns that do not pertain to that
department. Once the departmental workbooks are created, the row and column
presentation should be unchangable. I want to disable the worksheet_change
event code, so that the users of the departmental workbooks do not fire that
code that changes their departmetal presentation.

I hope this overview helps.
--
Thanks.
Chuck M.


"Ron de Bruin" wrote:

> Yes this is possible
> Are you the only user of the code ?
>
> let me know than I give you a good answer
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Chuck M" <(E-Mail Removed)> wrote in message news:0D5D9442-C3BA-4B72-B1BB-(E-Mail Removed)...
> > Hi,
> > I have a worksheet that has code in the Worksheet_Change event. Through VBA,
> > I copy that worksheet to a new workbook. Once the Copy is complete, I would
> > like to delete the Worksheet_Change event code in the copied (new) worksheet.
> > Can this be done via VBA?
> > --
> > TIA
> > Chuck M.
>

See Chip's code then
http://www.cpearson.com/excel/vbe.aspx

The other option is to create a new workbook with one sheet and copy all the cells in
this worksheet

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chuck M" <(E-Mail Removed)> wrote in message news:859446EF-FC2A-4C8F-BD6E-(E-Mail Removed)...
> Hi Ron,
> Yes I am. The main workbook I created is a company budget with many columns
> of data. The columns are hidden and unhidden based on code that fires on the
> worksheet-change event. I have a macro that creates separate workbooks for
> different departments within the company. Once the company budget is copied
> to a new workbook, I hide rows and columns that do not pertain to that
> department. Once the departmental workbooks are created, the row and column
> presentation should be unchangable. I want to disable the worksheet_change
> event code, so that the users of the departmental workbooks do not fire that
> code that changes their departmetal presentation.
>
> I hope this overview helps.
> --
> Thanks.
> Chuck M.
>
>
> "Ron de Bruin" wrote:
>
>> Yes this is possible
>> Are you the only user of the code ?
>>
>> let me know than I give you a good answer
>>
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>>
>>
>> "Chuck M" <(E-Mail Removed)> wrote in message news:0D5D9442-C3BA-4B72-B1BB-(E-Mail Removed)...
>> > Hi,
>> > I have a worksheet that has code in the Worksheet_Change event. Through VBA,
>> > I copy that worksheet to a new workbook. Once the Copy is complete, I would
>> > like to delete the Worksheet_Change event code in the copied (new) worksheet.
>> > Can this be done via VBA?
>> > --
>> > TIA
>> > Chuck M.
>>

Looks like Chip has the answer I was looking for.

Thanks for pointing me in that direction.

--
Have a good day.
Chuck M.


"Ron de Bruin" wrote:

> See Chip's code then
> http://www.cpearson.com/excel/vbe.aspx
>
> The other option is to create a new workbook with one sheet and copy all the cells in
> this worksheet
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Chuck M" <(E-Mail Removed)> wrote in message news:859446EF-FC2A-4C8F-BD6E-(E-Mail Removed)...
> > Hi Ron,
> > Yes I am. The main workbook I created is a company budget with many columns
> > of data. The columns are hidden and unhidden based on code that fires on the
> > worksheet-change event. I have a macro that creates separate workbooks for
> > different departments within the company. Once the company budget is copied
> > to a new workbook, I hide rows and columns that do not pertain to that
> > department. Once the departmental workbooks are created, the row and column
> > presentation should be unchangable. I want to disable the worksheet_change
> > event code, so that the users of the departmental workbooks do not fire that
> > code that changes their departmetal presentation.
> >
> > I hope this overview helps.
> > --
> > Thanks.
> > Chuck M.
> >
> >
> > "Ron de Bruin" wrote:
> >
> >> Yes this is possible
> >> Are you the only user of the code ?
> >>
> >> let me know than I give you a good answer
> >>
> >>
> >> --
> >>
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl/tips.htm
> >>
> >>
> >> "Chuck M" <(E-Mail Removed)> wrote in message news:0D5D9442-C3BA-4B72-B1BB-(E-Mail Removed)...
> >> > Hi,
> >> > I have a worksheet that has code in the Worksheet_Change event. Through VBA,
> >> > I copy that worksheet to a new workbook. Once the Copy is complete, I would
> >> > like to delete the Worksheet_Change event code in the copied (new) worksheet.
> >> > Can this be done via VBA?
> >> > --
> >> > TIA
> >> > Chuck M.
> >>
>