Compile error: Variable not defined

KDub

New Member
Joined
Sep 16, 2020
Messages
1
Office Version
  1. 2010
Platform
  1. Windows
Hi All,

I have popped a piece of code together from various sources in an attempt to disable the ribbon when minimizing.

I am reasonably new to Excel VBA Code and I am receiving a Compile error: Variable not defined on the below code:

VBA Code:
Sub StartLoop()
Dim ShedRecalc As String

SchedRecalc = Now + TimeValue("00:00:01")

Application.OnTime SchedRecalc, "Recalc"

If Application.WindowState = xlMaximized And ActiveWorkbook.Name = "[COLOR=#ff0000]DocumentSignposting_V3.8.xlsm[/COLOR]" Then
    
    Application.DisplayFullScreen = True
    
ElseIf ActiveWorkbook.Name <> "[COLOR=#ff0000]DocumentSignposting_V3.8.xlsm[/COLOR]" Then

    Application.DisplayFullScreen = False
    
End If
End Sub

Any help?
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
6,375
Office Version
  1. 2019
Platform
  1. Windows
I am receiving a Compile error: Variable not defined on the below code:

Rich (BB code):
Dim SchedRecalc As String

SchedRecalc = Now + TimeValue("00:00:01")


End Sub



Hi welcome to forum

You have a typo in your declaration which probably is why the compiler is complaining - try amending where shown

Dave
 

Watch MrExcel Video

Forum statistics

Threads
1,122,597
Messages
5,597,091
Members
414,122
Latest member
eazyyexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top