ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Restore Borders Automatically (https://www.excelbanter.com/excel-programming/357855-restore-borders-automatically.html)

beans_21[_12_]

Restore Borders Automatically
 

Hi,

I'm not sure if this is possible :confused: ....I've created a bookin
system and it has a grid which is highlighted with borders. User ca
enter bookings and have been encouraged to merge cells together t
hightlight bookings which strech over a number of cells. If th
booking is later moved or removed it takes the formatting of th
borders away with it. Is there anyway that the borders can remain i
tact? Can they be locked for with some VBA code for example?

After some user feedback this was one of the major issues bought up fo
inexperienced users who didn't know how to restore the border
manually.

Any help on this topic would be VERY much appeciated!

Thanks,

Dave :

--
beans_2
-----------------------------------------------------------------------
beans_21's Profile: http://www.excelforum.com/member.php...fo&userid=3028
View this thread: http://www.excelforum.com/showthread.php?threadid=52919



All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com