Excel worksheet with VBE codes don't work elsewhere

L

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
 
D

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.
 
L

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
 
C

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]...
 
Top