opening an excel page without the toolbars
 

is it possible to run an excel workbook which contains macros to do all the
required input without actually having excel open
--
BD3

opening an excel page without the toolbars
 

You have to have excel open to open and workbook and you have to have a
workbook open to run it macros. That said, you could make the application
(excel) not visible. This assumes you are running some code to do this
(from where I don't know).

--
Regards,
Tom Ogivly

"bigdaddy3" wrote in message
...
is it possible to run an excel workbook which contains macros to do all
the
required input without actually having excel open
--
BD3

opening an excel page without the toolbars
 

yes i would like to have excel running in the background but only my workbook
visible
--
BD3


"Tom Ogilvy" wrote:

You have to have excel open to open and workbook and you have to have a
workbook open to run it macros. That said, you could make the application
(excel) not visible. This assumes you are running some code to do this
(from where I don't know).

--
Regards,
Tom Ogivly

"bigdaddy3" wrote in message
...
is it possible to run an excel workbook which contains macros to do all
the
required input without actually having excel open
--
BD3

opening an excel page without the toolbars
 

That is not what Tom was saying. If you make the Excel application not
visible, workbooks which are part of the Excel application will also not be
visible. They will however continue to run code, such as display userforms.

--
HTH

Bob Phillips

"bigdaddy3" wrote in message
...
yes i would like to have excel running in the background but only my
workbook
visible
--
BD3


"Tom Ogilvy" wrote:

You have to have excel open to open and workbook and you have to have a
workbook open to run it macros. That said, you could make the
application
(excel) not visible. This assumes you are running some code to do this
(from where I don't know).

--
Regards,
Tom Ogivly

"bigdaddy3" wrote in message
...
is it possible to run an excel workbook which contains macros to do
all
the
required input without actually having excel open
--
BD3

opening an excel page without the toolbars
 

Hi Bob, does that mean if i have a userform to start the whole program off
can i then call an excel workbook from that but it would still open the whole
excel page not just my workbook without any toolbars,address bar,etc,if you
know what i mean because thats what i want no toolbars or anything showing
other than my formatted workbook from address bar down
--
BD3


"Bob Phillips" wrote:

That is not what Tom was saying. If you make the Excel application not
visible, workbooks which are part of the Excel application will also not be
visible. They will however continue to run code, such as display userforms.

--
HTH

Bob Phillips

"bigdaddy3" wrote in message
...
yes i would like to have excel running in the background but only my
workbook
visible
--
BD3


"Tom Ogilvy" wrote:

You have to have excel open to open and workbook and you have to have a
workbook open to run it macros. That said, you could make the
application
(excel) not visible. This assumes you are running some code to do this
(from where I don't know).

--
Regards,
Tom Ogivly

"bigdaddy3" wrote in message
...
is it possible to run an excel workbook which contains macros to do
all
the
required input without actually having excel open
--
BD3

opening an excel page without the toolbars
 

Essentially yes.

If you are happy to have the Excel window open, but just don't want the
commandbars etc, that is, you can run this code when the workbook opens, and
closes, which hides all bars and the formula bar.

Option Explicit

Private mFormulaBar

Private Sub Workbook_Activate()
Dim oCB As CommandBar

'Remove commandbars
For Each oCB In Application.CommandBars
oCB.Enabled = False
Next

'RemoveFormulaBar
mFormulaBar = Application.DisplayFormulaBar
Application.DisplayFormulaBar = False
End Sub


Private Sub Workbook_Deactivate()
Dim oCB As CommandBar

'Restore commandbars
For Each oCB In Application.CommandBars
oCB.Enabled = True
Next

'RestoreFormulaBar
Application.DisplayFormulaBar = mFormulaBar
End Sub


'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--
HTH

Bob Phillips

"bigdaddy3" wrote in message
...
Hi Bob, does that mean if i have a userform to start the whole program off
can i then call an excel workbook from that but it would still open the
whole
excel page not just my workbook without any toolbars,address bar,etc,if
you
know what i mean because thats what i want no toolbars or anything showing
other than my formatted workbook from address bar down
--
BD3


"Bob Phillips" wrote:

That is not what Tom was saying. If you make the Excel application not
visible, workbooks which are part of the Excel application will also not
be
visible. They will however continue to run code, such as display
userforms.

--
HTH

Bob Phillips

"bigdaddy3" wrote in message
...
yes i would like to have excel running in the background but only my
workbook
visible
--
BD3


"Tom Ogilvy" wrote:

You have to have excel open to open and workbook and you have to
have a
workbook open to run it macros. That said, you could make the
application
(excel) not visible. This assumes you are running some code to do
this
(from where I don't know).

--
Regards,
Tom Ogivly

"bigdaddy3" wrote in message
...
is it possible to run an excel workbook which contains macros to
do
all
the
required input without actually having excel open
--
BD3

opening an excel page without the toolbars
 

Thanks Bob
--
BD3


"Bob Phillips" wrote:

Essentially yes.

If you are happy to have the Excel window open, but just don't want the
commandbars etc, that is, you can run this code when the workbook opens, and
closes, which hides all bars and the formula bar.

Option Explicit

Private mFormulaBar

Private Sub Workbook_Activate()
Dim oCB As CommandBar

'Remove commandbars
For Each oCB In Application.CommandBars
oCB.Enabled = False
Next

'RemoveFormulaBar
mFormulaBar = Application.DisplayFormulaBar
Application.DisplayFormulaBar = False
End Sub


Private Sub Workbook_Deactivate()
Dim oCB As CommandBar

'Restore commandbars
For Each oCB In Application.CommandBars
oCB.Enabled = True
Next

'RestoreFormulaBar
Application.DisplayFormulaBar = mFormulaBar
End Sub


'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--
HTH

Bob Phillips

"bigdaddy3" wrote in message
...
Hi Bob, does that mean if i have a userform to start the whole program off
can i then call an excel workbook from that but it would still open the
whole
excel page not just my workbook without any toolbars,address bar,etc,if
you
know what i mean because thats what i want no toolbars or anything showing
other than my formatted workbook from address bar down
--
BD3


"Bob Phillips" wrote:

That is not what Tom was saying. If you make the Excel application not
visible, workbooks which are part of the Excel application will also not
be
visible. They will however continue to run code, such as display
userforms.

--
HTH

Bob Phillips

"bigdaddy3" wrote in message
...
yes i would like to have excel running in the background but only my
workbook
visible
--
BD3


"Tom Ogilvy" wrote:

You have to have excel open to open and workbook and you have to
have a
workbook open to run it macros. That said, you could make the
application
(excel) not visible. This assumes you are running some code to do
this
(from where I don't know).

--
Regards,
Tom Ogivly

"bigdaddy3" wrote in message
...
is it possible to run an excel workbook which contains macros to
do
all
the
required input without actually having excel open
--
BD3