G
Guest
I am trying to get the Table-driven commandbar routine (from Bullen, Bovey
and Green's "Professional Excel Development" book) to work in my project.
The 1 thing that I see that is different after exporting the 3 modules and
copying the spreadsheet table:
The name of the worksheet tab is set to wksCommandBars; however the name
that shows in Project Explorer under "Microsoft Excel Objects" is :
next to the worksheet icon... "sheet1 (wksCommandBars)"
The example code I was copying from was showing ...
"wksCommandBars (wksCommandBars)"
How do I make project Explorer have the correct name? (i'm hoping that it
will start working then)
*************************************
or if Steven,Rob or John are reading this... perhaps one of you can tell me
what I have done wrong.
the error i'm getting is a compile error (object not defined). The debug
window shows the "wksCommandBars" portion in reverse video :
' Copy the picture to the clipboard and set as the Picture.
wksCommandBars.Shapes(Trim$(Left$(uCtlProperties.vFaceID, _
lSeparator-1))).CopyPicture xlScreen, xlBitmap
it is inside the ctlAddNewControl, function.... when I try to call the
bBuildCommandBars() function
I have even tried coying (export/import)ing all of the modules to my
workbook, but I still get the same error. The ONLY difference I can find, is
the name of the worksheet in project explorer. Perhaps I copied something
wrong... I also had tried exporting the worksheet... it exported as a class
module and when I imported it, it made a class module section which is
definitely different than the example.
If I should be directing these kinds of questions elsewhere, just let me know.
and Green's "Professional Excel Development" book) to work in my project.
The 1 thing that I see that is different after exporting the 3 modules and
copying the spreadsheet table:
The name of the worksheet tab is set to wksCommandBars; however the name
that shows in Project Explorer under "Microsoft Excel Objects" is :
next to the worksheet icon... "sheet1 (wksCommandBars)"
The example code I was copying from was showing ...
"wksCommandBars (wksCommandBars)"
How do I make project Explorer have the correct name? (i'm hoping that it
will start working then)
*************************************
or if Steven,Rob or John are reading this... perhaps one of you can tell me
what I have done wrong.
the error i'm getting is a compile error (object not defined). The debug
window shows the "wksCommandBars" portion in reverse video :
' Copy the picture to the clipboard and set as the Picture.
wksCommandBars.Shapes(Trim$(Left$(uCtlProperties.vFaceID, _
lSeparator-1))).CopyPicture xlScreen, xlBitmap
it is inside the ctlAddNewControl, function.... when I try to call the
bBuildCommandBars() function
I have even tried coying (export/import)ing all of the modules to my
workbook, but I still get the same error. The ONLY difference I can find, is
the name of the worksheet in project explorer. Perhaps I copied something
wrong... I also had tried exporting the worksheet... it exported as a class
module and when I imported it, it made a class module section which is
definitely different than the example.
If I should be directing these kinds of questions elsewhere, just let me know.