Protecting WordArt objects in Excel
 

Hi,

As part of a project my colleagues and I have come up with a crazy
idea where a user would be able to drag and drop WordArt objects where
ever they want on a worksheet in order to design a letter (Mail Merge
style!) using tags which would be called "Address Line 1", "Person
Name" and the like.

The problem is we don't want the user to be able to edit the text, or
change any other of those esoteric WordArt options, so we need some
kind of way of protecting the WordArt objects to limit what the user
can do to them.

I have done a heavy amount of investigation into this and am pretty
much convinced that I've reached the limits of what VBA can do, but I
thought I'd give the forum a shot anyway.

The best I've come up with so far is resetting the WordArt objects to
their default value with the WorkSheet Change event but this is a
pretty messy solution as the client can still make all the changes
they want, only to be confused when it resets itself.

I'd appreciate any insight you guys have.

Thanks,

Des

Protecting WordArt objects in Excel
 

Des,
As you do not need to edit the WordArt (indeed you want to prevent it), why
not Image boxes instead, filled with suitable graphics and formatted
transparent background.
Then you can allow the use the move them or use the objects events
(MouseMove, MouseDown) to control movement.

NickHK

wrote in message
oups.com...
Hi,

As part of a project my colleagues and I have come up with a crazy
idea where a user would be able to drag and drop WordArt objects where
ever they want on a worksheet in order to design a letter (Mail Merge
style!) using tags which would be called "Address Line 1", "Person
Name" and the like.

The problem is we don't want the user to be able to edit the text, or
change any other of those esoteric WordArt options, so we need some
kind of way of protecting the WordArt objects to limit what the user
can do to them.

I have done a heavy amount of investigation into this and am pretty
much convinced that I've reached the limits of what VBA can do, but I
thought I'd give the forum a shot anyway.

The best I've come up with so far is resetting the WordArt objects to
their default value with the WorkSheet Change event but this is a
pretty messy solution as the client can still make all the changes
they want, only to be confused when it resets itself.

I'd appreciate any insight you guys have.

Thanks,

Des