Macro file save as, saving sheet not workbook
It's probably not harmful -- but it could cause trouble for the person opening
the file. They might be confused about the "this file contains macros" warning
or even worse, they could run it.
But I've never seen a recorded macro get named Record1 -- unless I changed the
name. Mine are named Macro1, Macro2, ...
Are you recording a macro in that new workbook? If you are, then you could
always store the recorded macro in a different workbook.
And if your worksheets have code behind them (say for events or controls), then
that code will get copied with the worksheet.
I'd be very hesitant to call it a bug. Most bugs I see are just my errors.
al007 wrote:
Dave,
Where I record a macro while copying 2 sheets in a new workbook
,converting the formula to values & saving as a new file I get a macro
in the new file call "Record1" & I can't delete it - Is it a bug or
harmful for the new file??
Thxs
--
Dave Peterson
|