Displaying scrollbars in embedded Excel object

[FelicianoRa@coned.com]

While I have no problem displaying my data to my embedded Excel object on my Access form, I am have been having a lot of trouble displaying the scrollbars for it. (Do I need to use the 'New' keyword for my workbook when I'm trying to refer to an object I've already placed on the form in Design mode?). Can anyone point out what I'm doing wrong here? Thanks!



Dim internalWorkbook As Excel.Workbook
Dim internalSheet As Excel.Worksheet
'Screen output.
Set internalWorkbook = myGrid.Object
internalWorkbook.Application.DisplayScrollBars = True
Set internalSheet = internalWorkbook.Sheets(1)
internalSheet.ScrollArea = "" 'Enable scrolling for entire sheet.

[FelicianoRa@coned.com]

I have also tried this alternative to specify it at the sheet level instead of at the workbook level:

internalSheet.Range(myScrollArea).Application.Disp layScrollBars = True

Neither approach throws any error, but neither is working to display the scroll bars.