message "fixed objects will move" HELP!
in [Programming]
|
Prev: Shape.OnAction stops working after workbook closed and re-opened
Next: Error message on opening Excel after deleting add-in file
From: Valeria on 30 Apr 2010 11:27 Dear experts, after spending 3 weeks working on macros for a long workbook I had finally reached what I wanted. i have just realized now that, when autofiltering on one worksheet, I am getting now the warning "fixed objects will move" which I have to click on hundreds of times to get rid of! Odd enough not to appear any longer once all items in the autofilter list have been selected once. Can you please help me with this? I am getting really depressed as the work was ready... I have also tried to look at previous posts and the hint could be that I have many comments in my worksheet, however I need them so they cannot be deleted. I don't have any boxes or other objects. Many thanks! Best regards -- Valeria
From: JLGWhiz on 30 Apr 2010 13:06 Did you try putting Application.DisplayAlerts = False just before the AutoFilter executes and then Application.DisplayAlerts = True after AutoFilter executes.? "Valeria" <Valeria(a)discussions.microsoft.com> wrote in message news:2C746134-3CF7-4332-8477-AA3B67794C1C(a)microsoft.com... > Dear experts, > after spending 3 weeks working on macros for a long workbook I had finally > reached what I wanted. > i have just realized now that, when autofiltering on one worksheet, I am > getting now the warning "fixed objects will move" which I have to click on > hundreds of times to get rid of! Odd enough not to appear any longer once > all > items in the autofilter list have been selected once. > > Can you please help me with this? I am getting really depressed as the > work > was ready... > I have also tried to look at previous posts and the hint could be that I > have many comments in my worksheet, however I need them so they cannot be > deleted. I don't have any boxes or other objects. > > Many thanks! > Best regards > > > > > -- > Valeria
From: Valeria on 30 Apr 2010 17:53
Hi, no I haven't: how do you express this with code? Would you put it in the worsheet change event and not in a module I guess? Many thanks for your very precious help. Best regards -- Valeria "JLGWhiz" wrote: > Did you try putting Application.DisplayAlerts = False just before the > AutoFilter executes and then Application.DisplayAlerts = True after > AutoFilter executes.? > > > > "Valeria" <Valeria(a)discussions.microsoft.com> wrote in message > news:2C746134-3CF7-4332-8477-AA3B67794C1C(a)microsoft.com... > > Dear experts, > > after spending 3 weeks working on macros for a long workbook I had finally > > reached what I wanted. > > i have just realized now that, when autofiltering on one worksheet, I am > > getting now the warning "fixed objects will move" which I have to click on > > hundreds of times to get rid of! Odd enough not to appear any longer once > > all > > items in the autofilter list have been selected once. > > > > Can you please help me with this? I am getting really depressed as the > > work > > was ready... > > I have also tried to look at previous posts and the hint could be that I > > have many comments in my worksheet, however I need them so they cannot be > > deleted. I don't have any boxes or other objects. > > > > Many thanks! > > Best regards > > > > > > > > > > -- > > Valeria > > > . > |