2

When I record macros the code does not work and there are several lines highlighted in red which have just a "." on the left side of the equal sign.

It appears to me that the macro is doing something along the lines of just registering my changes and not assigning the default settings by itself.

enter image description here

I got over the issue by downgrading to Excel 13 from Excel 16.

Community
  • 1
  • 1
Jay Haran
  • 123
  • 1
  • 9
  • Very strange. There should be property names after the '.' ... Have you tried recording the macro? – 3-14159265358979323846264 Jul 18 '18 at 16:53
  • Yes, I have tried recording the macro. It throws a syntax error when I run the macro which is expected. It is very strange the tutorials I am following don't seem to have this issue. – Jay Haran Jul 18 '18 at 16:55
  • I've not seen that before. It's certainly not normal behaviour. Let's see if anyone else has any input before I suggest reinstalling office!! – 3-14159265358979323846264 Jul 18 '18 at 16:57
  • 1
    The only foreignkeycolumn I know of is a property of ModelRelationship. What are you trying to do? –  Jul 18 '18 at 17:13
  • That is not valid code. what procedure are you trying to have the macro recorder accomplish? (i.e. steps necessary to reproduce what you have done) – Ron Rosenfeld Jul 18 '18 at 17:28
  • I am just doing random stuff like changing size of a font, filling a box. Just to try out recording some macros via the record key, but it must be the setting of my excel or something it doesn't record the macro effectively and the recorded looks like the one above. I am very new to VBA this is the first thing I tried to do. Just to record macros and read the code. – Jay Haran Jul 18 '18 at 22:14
  • I got over the issue by downgrading to excel 13 it would be good if someone could figure out what the issue I was having with excel 16 was because no one could help me. – Jay Haran Jul 20 '18 at 09:40

0 Answers0