Solved

Code Help

Posted on 2014-12-15
18
158 Views
Last Modified: 2014-12-18
Hi Experts,

I have one code which is provided by Sir.Gowflow. for previous question. it is working fine for few days but after long break of 30 days I had checked it is not working. all buttons are disabled. please let me know how to over  come on this issue. this is the link of my solved question.

See attached file.
DelSpecificRowCSV-V03--1-.xlsm
0
Comment
Question by:itjockey
  • 10
  • 6
  • 2
18 Comments
 
LVL 23

Expert Comment

by:Michael74
ID: 40501464
I opened the file and the buttons are working for me

This could be related to your Excel security settings

http://office.microsoft.com/en-au/excel-help/change-macro-security-settings-in-excel-HP010096919.aspx

Michael
0
 
LVL 14

Expert Comment

by:DrTribos
ID: 40501641
I think I had a similar thing happen this morning. Something has changed and command buttons in my document are not working :-(

Didn't get time to test.
0
 
LVL 14

Expert Comment

by:DrTribos
ID: 40501651
First observation for my similar issue  is that the buttons work on a different PC.  Makes me think design mode might be 'on' in the  VBA IDE. Can't check as I am on a  different PC.
0
 
LVL 8

Author Comment

by:itjockey
ID: 40501889
Changed macro setting to enable all...but still problem not solved. it happens to this file only. other files which have buttons is working fine.

Thanks
0
 
LVL 14

Expert Comment

by:DrTribos
ID: 40501891
See if you are in design mode any where?
0
 
LVL 8

Author Comment

by:itjockey
ID: 40501914
how do I check?
0
 
LVL 23

Expert Comment

by:Michael74
ID: 40501918
Enable the developer tab
http://msdn.microsoft.com/en-us/library/bb608625.aspx

Then on the this tab ensure the button "Design Mode" in the Controls section is not enabled
0
 
LVL 14

Expert Comment

by:DrTribos
ID: 40502000
Try and drag one of your buttons to a new location... for me I got a message that says "There are too many edits in the document....."  

MS is giving me the $4!7$   >-|
0
 
LVL 14

Accepted Solution

by:
DrTribos earned 500 total points
ID: 40502015
Ok... dragging might have been a red herring... would be interested to know what happens for you.  I deleted some custom XML from my document and that got rid of the error message.  Now I can drag and drop my buttons.

Next test - try and add a new button... I get:  The program used to create this object is forms.  That program is either not installed on your computer or it is not responding....

Well, this could explain why it IS working on my other computers... Hmmm... WTF MS!?

Oh yeah, here it is and here is the MS KB article.
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 14

Expert Comment

by:DrTribos
ID: 40502031
Ok... more info.  And here is what I did:

0. Close WORD (and the rest of MS Office no doubt, don't forget Outlook)

1. Start > cmd.exe (right click and open command window as Admin)

2a. Open file explorer and search for *.exd (will likely be slow, searching unindexed locations)

2b. Run each of the following (read the article, some locations might not exist).  Note: you can paste to the cmd.exe window by right clicking the mouse and selecting paste (Ctrl + V won't work)
  del %temp%\vbe\*.exd
  del %temp%\excel8.0\*.exd
  del %appdata%\microsoft\forms\*.exd
  del %appdata%\microsoft\local\*.exd
  del %temp%\word8.0\*.exd
  del %temp%\ PPT11.0\*.exd

Some of these files did not want to go... I searched more than once.

3. Restart... (will update after restart....
0
 
LVL 14

Expert Comment

by:DrTribos
ID: 40502044
ok... this is disturbing... none of the existing controls in my document work now.  I have to re-add new controls.  

Even worse, I use "ThisDocument" quite a lot and now compile is coming back with variable not defined...
0
 
LVL 14

Expert Comment

by:DrTribos
ID: 40502050
Ok... restarted Word and ThisDocument started working again.  Mild heart attack.

When I right click my old button, I see the word "Object" (3rd from the bottom) - click "Object" and I get "This object is corrupt or is no longer available"  

When I add a new command button I have a different word "CommandButton Object" - click that and everything seems ok.

I can't begin to imagine how disruptive this latest MS trick is going to be!
0
 
LVL 8

Author Comment

by:itjockey
ID: 40504073
Sorry For Delay In Reply.

I am not IT guy.....not understand too much ...is there any way to re write code in simple manner ?

Thanks
0
 
LVL 14

Expert Comment

by:DrTribos
ID: 40504141
Ok... I don't quite understand where you are at... what do you mean by rewrite code?

In a nutshell, MicroSoft released a security patch - and so far as command buttons in documents are involved it broke your computer and my computer.

The links provided take you through the steps... I summarised the main points - search for and destroy all .exd files on your system....

Have you done that? What step are you up to?

Note: According to MS the steps to fix may, or may not work.  Depends on a few things I guess.  For me they did not work.  I had to recreate my buttons.  I only had 5 buttons so was not a big deal.  I did notice that the buttons were corrupted and I was unable to figure out how to fix them programmatically...
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 40506301
Working For Me......Thank You Very Much
0
 
LVL 14

Expert Comment

by:DrTribos
ID: 40506368
No worries - glad you got it sorted. Wish mine waa an easy fix.
0
 
LVL 8

Author Comment

by:itjockey
ID: 40506488
Fungus crossed :)
0
 
LVL 8

Author Comment

by:itjockey
ID: 40506581
Fingers crossed :)     sorry typo mistake
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now