+ Reply to Thread
Results 1 to 3 of 3

Don't select a cell after macro runs ???

  1. #1
    Registered User
    Join Date
    11-28-2006
    Posts
    55

    Don't select a cell after macro runs ???

    Hi

    Can anyone tell me if its possible to create a macro that once run doesn't have to select a cell?

    At present i have macro's that change the display of a work book but i have to select a cell so that my buttons are not highlighted after the macro runs. Is there a way of not selecting anything at all?

    Many thanks

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,467
    There is always something selected. If not a object then a cell.

    Why not remember the active cell when you code starts and simple re select that at the end.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-28-2006
    Posts
    55
    Thanks Andy

    I thought that was the case but i just wanted to tidy things up a bit. Back to select a tiny cell again then!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1