Compile error hidden in sheet 1

**sam94** · 03-06-2015, 05:56 AM

Hi,

I'll try keep it short. Basically an order form we use for our division has been affected by this recent Microsoft excel update to activeX, we've managed to get around the problem for the majority of our computers by deleting the files hidden in appdata, however the error still occurs for others. I've been told it may have something to do with some sort of referencing in the VBA?

Heres the code from the sheet1 vba, can anyone see the problem?

Please Login or Register  to view this content.

Thanks,

Sam

**Kyle123** · 03-06-2015, 06:09 AM

What's the actual error if you unprotect the VBA?

**sam94** · 03-06-2015, 06:19 AM

Originally Posted by Kyle123

What's the actual error if you unprotect the VBA?

Also, please use code tags:
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Sorry - edited my post,

How do I find out the exact error on VBA?

Sam

**Kyle123** · 03-06-2015, 06:20 AM

Unhide the sheet and remove any password you may have on the VBA project

**sam94** · 03-06-2015, 09:42 AM

The first line comes up with an error, stating it might be referencing something?

Please Login or Register  to view this content.

**Kyle123** · 03-06-2015, 10:01 AM

Do you have any missing references?

**sam94** · 03-06-2015, 10:04 AM

Originally Posted by Kyle123

Do you have any missing references?

I checked on tools>references within VBA and it didn't state any were missing

Compile error hidden in sheet 1

LinkBack

Thread Tools

Rate This Thread

Display

Compile error hidden in sheet 1

Re: Compile error hidden in sheet 1

Re: Compile error hidden in sheet 1

Re: Compile error hidden in sheet 1

Re: Compile error hidden in sheet 1

Re: Compile error hidden in sheet 1

Re: Compile error hidden in sheet 1

Thread Information

Users Browsing this Thread

Similar Threads

Compile error in hidden module: Sheet 1

Compile error in hidden module sheet 1

[SOLVED] Compile Error in Hidden Module and Compile Error: Can't find project or library

"Compile Error in hidden module in sheet 1" in excel

Compile Error in Hidden Sheet

Bookmarks

Bookmarks

Posting Permissions