#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default Duplicate macros?

I'm sure the answer will be embarrassingly obvious but why does my
drop-down list of macros in Excel 365 contain duplicates for every one
please? Perhaps some obscure file save setting I've accidentally set?

https://dl.dropboxusercontent.com/u/...plicates-1.jpg

--
Terry, East Grinstead, UK
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,182
Default Duplicate macros?

I'm sure the answer will be embarrassingly obvious but why does my
drop-down list of macros in Excel 365 contain duplicates for every
one please? Perhaps some obscure file save setting I've accidentally
set?

https://dl.dropboxusercontent.com/u/...plicates-1.jpg


Apparently you have 2 versions of each file running; original plus auto
saved. Did you crash Excel and it auto restarted, perhaps?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default Duplicate macros?

GS wrote:

I'm sure the answer will be embarrassingly obvious but why does my
drop-down list of macros in Excel 365 contain duplicates for every
one please? Perhaps some obscure file save setting I've accidentally
set?

https://dl.dropboxusercontent.com/u/...plicates-1.jpg


Apparently you have 2 versions of each file running; original plus auto
saved. Did you crash Excel and it auto restarted, perhaps?


Thanks Garry, that looks to be exactly what must have happened. I've
found and deleted Personal (Autosaved).xlsb, and two other similar
duplicate 'macro containers' from ancient Excel versions.

List now much less cluttered, but still needs heavy pruning to remove or
edit macros I wrote around 20 years ago!

--
Terry, East Grinstead, UK
  #4   Report Post  
Banned
 
Posts: 6
Default

up phụ bác chủ dùng khá l* ok mua mấy cái rồi mai chuyển em cái nữa nhé
_________________
micropigmentacao

https://t.co/ckTcsblPMy
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,182
Default Duplicate macros?

GS wrote:

I'm sure the answer will be embarrassingly obvious but why does my
drop-down list of macros in Excel 365 contain duplicates for every
one please? Perhaps some obscure file save setting I've
accidentally set?

https://dl.dropboxusercontent.com/u/...plicates-1.jpg


Apparently you have 2 versions of each file running; original plus
auto saved. Did you crash Excel and it auto restarted, perhaps?


Thanks Garry, that looks to be exactly what must have happened. I've
found and deleted Personal (Autosaved).xlsb, and two other similar
duplicate 'macro containers' from ancient Excel versions.

List now much less cluttered, but still needs heavy pruning to remove
or edit macros I wrote around 20 years ago!


If you make them 'Private' scope they will not appear in the list.
Also, you could make yourself a menuitem that fires all the macros you
commonly use. (I do this with a toolbar named "MyUtils")

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
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
Macros to delete duplicate entry Bakar Excel Programming 2 October 19th 12 04:57 AM
Good at Macros? I'm Trying to find duplicate entries. David B Excel Discussion (Misc queries) 3 April 19th 07 09:20 PM
combining macros - compile error: duplicate declaration in current scope J.W. Aldridge Excel Programming 1 December 9th 06 03:50 PM
Duplicate all Macros? SteveC Excel Programming 2 June 7th 06 07:39 PM
Duplicate CommandButton macros Blue Hornet Excel Programming 4 December 30th 05 02:53 AM


All times are GMT +1. The time now is 11:58 PM.

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

About Us

"It's about Microsoft Excel"