Macro not getting executed because of installation of MS office

[Pavan.Sada.PS]

Hello Friends,

I have built an user form using Excel 2007 version and created a huge success in my company. Till Yesterday it was working really awsome.. But Late night I installed MS office 2010 in my TP and now the buttons are not getting executed/ clicked.

Error says Compile error : hidden module in sheet1
Some time it also says : (as per the attachment)

This is a tool created for hiring request submitting process. Yesterday I got reward from Area Vice President and I am really scared that I will be fired if it does not work. Please do help me in how to fix this issue.

The basic issue is that I am not able to click/move/delete on any screenshot/object/file pasted in worksheet. also i suspect error on sheet1 Selection change macro with regard to view and edit record button

Password to access the code: pavangbs
You could call me at 9740281055

Note: I have deleted the sheet3 for time being as it includes lot of screenshots explaining the steps for using this tool

 

[NARAYANK991]

Hi Pavan ,

I am not finding any problem in executing ; can you explain the steps to be followed , and also when the posted error appears ?

I clicked on the button Click To Record Data , and the UserForm is displayed ; if I then click on the Click To Record Data button in the last tab , those fields which have not been filled in , or those which have invalid data are highlighted.

Probably you should retry installing Excel 2010.

Narayan

 

[Pavan.Sada.PS]

Hello Narayan,

My problem is i am not able to click on Click To Record Data button.. Any how let me try to re-install Excel 2010 and get back to you with the heads up..

 

[Hui]

Completely Turn off the PC
Start it again
Try your model again

 

[Deepak]

Hi,

If nothing helps then try two things & check one by one.
1. clear temporary files.
2. unlock the VBA then try: it will highligh the error part.

if still issue then share unlocked version/password.