Protecting

MarseL · Apr 5th, 2002, 06:23 AM

How do I go about protecting a cell's border and size format, so that when you click and drag it will leave the border behind?? Am i missing it in the protection choices??

Joe Was · Apr 5th, 2002, 06:48 AM

You cannot change the default for this operation without simulating the action with VBA macro code. JSW

MarseL · Apr 5th, 2002, 07:19 AM

I think I got it, by formatting style and locking it, it will keep the cells border. A tad bit easier than I thought

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

Apr 5th, 2002, 06:23 AM	#1
MarseL New Member Join Date: Apr 2002 Location: NOLa Posts: 2	How do I go about protecting a cell's border and size format, so that when you click and drag it will leave the border behind?? Am i missing it in the protection choices??

Apr 5th, 2002, 06:48 AM	#2
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	You cannot change the default for this operation without simulating the action with VBA macro code. JSW

Apr 5th, 2002, 07:19 AM	#3
MarseL New Member Join Date: Apr 2002 Location: NOLa Posts: 2	I think I got it, by formatting style and locking it, it will keep the cells border. A tad bit easier than I thought