Excel worksheet with VBE codes don't work elsewhere

[lazybear]

Hi,

Some of my excel worksheets with embedded controls and VBA codes don'
work when I open it on another PC. Is there another way to make i
work?

Thx

 

[Chip Pearson]

Specifically what problems are you having? Saying "don't work"
means absolutely nothing.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"lazybear"
message
news:[email protected]...

 

[Dave Peterson]

Maybe the other pc just doesn't allow macros to run.

Tools|macro|security|Security level tab
Use medium if they want to be prompted each time a workbook with macros is
opened
use Low if they always want to allow macros.

 

[lazybear]

Hi,

My problems are that some valid keywords like Ucase worked at my PC bu
had runtime error at another PC. Is there any libraries that I mus
enable before compiling my codes?

Th

 

[Chip Pearson]

This is a symptom of a missing type library, even if that library
does not contain the command that cause the compiler error. In
VBA, go to the Tools menu and choose References. If any are
marked MISSING, uncheck them if you don't need them If you do
need them, you'll have to Browse for the correct file location.

If it is a standard library that is MISSING, close Excel, go to
the Windows Start menu, choose Run, and enter

Excel.exe /regserver


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"lazybear"
message
news:[email protected]...