>O16 - DPF: {06C5A25C-0F08-49B1-BD92-192A61B85158} (ddm_download.ddm_control) - http://bins.dynamicdesktopmedia.com/cab/ddm_control.CAB
If I were you I would
0) run a microsoft-regclean first (ad-ware and spybot doesn't remove all crapy ad-softwares at all)
1) get rid of everything that has...
Hi Mike,
Thanks !
Ok, I just tried your suggestion. Unfortunately it doesn't solved my problem. Still got the same error message.
Should I really need to take care of clearing up memory when I'm using concstant ? I thought Excel was managing it (although badly...).
Really weird. I even...
Hi Geoff,
Sorry for being so long, I was on vacation for 2 weeks.
To answer you question. Yes, I did tried to hardcopy the name, but the error appeared again however...
In all cases, if I step over the two lines (by puting them into comments) :
.Worksheets("Items").Visible =...
I tried a debug with a break on value change for ItemsWshtName but nothing changed.
This constant is used everywhere in the code and this the
only part where ther is a problem.
It is weird, because it is perfectly working when I disable all the worksheet and workbook protection features in my...
Thanks for taking care of this case, xlbo.
They are delcared as constant in the public Module "Module1" :
'Worksheet names
Public Const MainWshtName As String = "Home"
Public Const UsersWshtName As String = "Users"
Public Const ServicesWshtName As String =...
Hello,
Currently trying to build with Excel a small application that gather information regarding Firewall rules, I'm mainly using validation lists in cells and updating them in Activate worksheet events.
The worksheets, workbook, and code are password protected, and I have to jungle with...
Yeepee !
Thanks Nath. You'r right it works fine.
The thing is that sometime one invents problem that shouldn't be there... :)
What I did was :
The code was created by the macro generator, so it was somehow still considered as a macro. Even after my small modification.
If I go to the menu...
Hello !
I'm trying to dynamically modify Validation Lists in an Excel document but I bumped into an issue I have been trying to work out for days without success. :-(
The weird thing is that it works fine when I run the code as a macro but it notifies me with an error when I run it through an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.