Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with selection when calling macro externally from VB6
hi I have the following code which runs fine when i call it from
within the macro of the spreadsheet. However when I canll it from outside, ie from vb6. I get a type mismatched error when i try and protect the cells. Has any one ever seen this before, is there any way around this? Is the obvious just to not use selection and manually set each cell indivually? here the code - thx alot. ActiveSheet.Cells.Select Selection.Locked = True <---gives me a type mismatch problem here when i call from outside ActiveSheet.Cells(1, 1).Select |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with selection when calling macro externally from VB6
Philip,
Have you created an Excel object, and referenced the Excel objects through that application object. For instance Set xlApp = GetObject("Excel.Application") Set xlWb = xlAPp.ActiveWorkbook xlWb.ActiveSheet.Cells.Locked = True -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) wrote in message om... hi I have the following code which runs fine when i call it from within the macro of the spreadsheet. However when I canll it from outside, ie from vb6. I get a type mismatched error when i try and protect the cells. Has any one ever seen this before, is there any way around this? Is the obvious just to not use selection and manually set each cell indivually? here the code - thx alot. ActiveSheet.Cells.Select Selection.Locked = True <---gives me a type mismatch problem here when i call from outside ActiveSheet.Cells(1, 1).Select |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calling macro in a formula | Excel Discussion (Misc queries) | |||
Calling an XLA macro from code | Excel Programming | |||
calling a macro from within a loop | Excel Programming | |||
calling a macro from within a loop | Excel Programming | |||
Calling macro in add-in. | Excel Programming |