#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default merge shortcut undo

Hello,
I recorded a macro to create a keyboard shortcut for merging cells. It works
well, but after I have merged cells, I cannot hit "undo" if I change my mind.
I have to use the unmerge command, which causes me to lose borders, etc in
the newly unmerged cells.

Is there a way to create a merge shortcut that can be reversed with "undo"?

thanks
Jen
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default merge shortcut undo

Hi,

the site http://www.jkp-ads.com/Articles/UndoWithVBA00.asp has some
information on this, but the procedure is not a simple one.

hth
---

"jen_writer" wrote:

Hello,
I recorded a macro to create a keyboard shortcut for merging cells. It works
well, but after I have merged cells, I cannot hit "undo" if I change my mind.
I have to use the unmerge command, which causes me to lose borders, etc in
the newly unmerged cells.

Is there a way to create a merge shortcut that can be reversed with "undo"?

thanks
Jen

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge option is not available. How to undo merge in this case? Gauri Excel Discussion (Misc queries) 1 October 9th 06 09:58 AM
shortcut key for merge cell nazim Excel Discussion (Misc queries) 3 June 23rd 06 11:50 PM
UNDO - how many times can I UNDO? Jane Excel Worksheet Functions 2 May 19th 05 03:03 AM
What is the Keyboard Shortcut of Merge and Centre Tool Command Rao Ratan Singh Excel Discussion (Misc queries) 3 February 13th 05 10:27 PM
Why is my undo function in Excel only can undo the last 1 or 2 ch. 1111111111111111111111111111111111111111 Excel Worksheet Functions 1 November 24th 04 11:13 AM


All times are GMT +1. The time now is 12:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"